﻿using System;
using System.Data;
using WP.Commons;

namespace WP.IM.DataEntity
{
    [System.ComponentModel.DesignerCategory("Code")]
    public class ImCategoryWKRatingDEL : DataSet, IDataEntity
    {
          //=========mCity ============================
        public const string TABLENAME_ImCategoryWKRating = "ImCategoryWKRating";
        public const string RECID = "RecId";
        public const string FItemID = "FItemID";
        public const string ItemNo = "Itemno";
        public const string ItemName = "ItemName";
        public const string WKName = "WKName";
        public const string WKProductID = "WKProductID";
        public const string CategoryID = "CategoryID";
        public const string CategoryName = "CategoryName";
        public const string SupNo = "SupNo";
        public const string SupName = "SupName";
        public const string QtyUnit = "QtyUnit";
        public const string RateQty = "RateQty";
        public const string RECSTAMP = "RecStamp";
        public const string Remark = "Remark";

        private System.Collections.Specialized.NameValueCollection mVarCollection = new System.Collections.Specialized.NameValueCollection();
        public System.Collections.Specialized.NameValueCollection VarCollection
        {
            get { return mVarCollection; }
            set { mVarCollection = value; }
        }

        public ImCategoryWKRatingDEL()
        {
            //Create mCity structure
            CreatemCityStructure();

        }

        //=========mCity============================
        private void CreatemCityStructure()
        {
            DataTable table;
            DataColumnCollection DCC;
            DataColumn DC = new DataColumn();
            table = new DataTable(TABLENAME_ImCategoryWKRating);
            DCC = table.Columns;

            DC = new DataColumn(RECID, typeof(System.Int32));
            DCC.Add(DC);

            DC = new DataColumn(FItemID, typeof(System.Int32));
            DCC.Add(DC);

            DC = new DataColumn(ItemNo  , typeof(System.String ));
            DC.DefaultValue ="";
            DCC.Add(DC);

            DC = new DataColumn(ItemName  , typeof(System.String ));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(CategoryName  , typeof(System.String));
            DC.DefaultValue =0;
            DCC.Add(DC);

            DC = new DataColumn(CategoryID , typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(QtyUnit  , typeof(System.String));
            DC.DefaultValue ="";
            DCC.Add(DC);

            DC = new DataColumn(RateQty  , typeof(System.Double ));
            DC.DefaultValue =0;
            DCC.Add(DC);

            DC = new DataColumn(RECSTAMP, typeof(System.Byte[]));
            DCC.Add(DC);

            DC = new DataColumn(SupNo  , typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(SupName , typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(Remark , typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(WKName , typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);


            DC = new DataColumn(WKProductID , typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            this.Tables.Add(table);
        }
    }
}
